package com.tt.fashionWebSite.domain;

import javax.persistence.*;
import java.io.Serializable;

/**
 * Created by isoft-work 5 on 11/19/14.
 */
@SuppressWarnings("serial")
@Entity
@Table(name = "sodo_cothe")
@NamedQueries({
        @NamedQuery(name = "getMemberMeasurement", query = "SELECT c FROM SoDoCoThe c") ,
      @NamedQuery(name = "SoDoCoThe.getMemberMeasurementByUser", query = "SELECT c FROM SoDoCoThe c " +
            "WHERE c.thongTinThanhVien.maTV = :email AND c.sdGioiTinhTuVan = :gender") ,
})
public class SoDoCoThe implements Serializable {
    public static final String GET_MEMBER_MEASUREMENT = "getMemberMeasurement";
   public static final String GET_MEMBER_MEASUREMENT_BY_USER = "SoDoCoThe.getMemberMeasurementByUser";


   @Id
   @Column(name = "MA_SD_COTHE")
   private String maSDCoThe;

   @Column(name = "SD_NGUC")
   private Long sdNguc;

   @Column(name = "SD_EO")
   private Long sdEo;

   @Column(name = "SD_MONG")
   private Long sdMong;

   @Column(name = "SD_DAILUNG")
   private Long sdDaiLung;

   @Column(name = "SD_DAITAY")
   private Long sdDaiTay;

   @Column(name = "SD_VAI")
   private Long sdVai;

   @Column(name = "SD_DUI")
   private Long sdDui;

   @Column(name = "SD_DAICHAN")
   private Long sdDaiChan;

   @Column(name = "SD_CHIEUCAO")
   private Double sdChieuCao;

   @Column(name = "SD_CANNANG")
   private Double sdCanNang;

   @Column(name = "GIOI_TINH_TV")
   private String sdGioiTinhTuVan;

   @ManyToOne
   @JoinColumn(name = "MA_TV")
   private ThongTinThanhVien thongTinThanhVien;

   public String getMaSDCoThe() {
      return maSDCoThe;
   }

   public void setMaSDCoThe(String maSDCoThe) {
      this.maSDCoThe = maSDCoThe;
   }

   public Long getSdNguc() {
      return sdNguc;
   }

   public void setSdNguc(Long sdNguc) {
      this.sdNguc = sdNguc;
   }

   public Long getSdEo() {
      return sdEo;
   }

   public void setSdEo(Long sdEo) {
      this.sdEo = sdEo;
   }

   public Long getSdMong() {
      return sdMong;
   }

   public void setSdMong(Long sdMong) {
      this.sdMong = sdMong;
   }

   public Long getSdDaiLung() {
      return sdDaiLung;
   }

   public void setSdDaiLung(Long sdDaiLung) {
      this.sdDaiLung = sdDaiLung;
   }

   public Long getSdDaiTay() {
      return sdDaiTay;
   }

   public void setSdDaiTay(Long sdDaiTay) {
      this.sdDaiTay = sdDaiTay;
   }

   public Long getSdVai() {
      return sdVai;
   }

   public void setSdVai(Long sdVai) {
      this.sdVai = sdVai;
   }

   public Long getSdDui() {
      return sdDui;
   }

   public void setSdDui(Long sdDui) {
      this.sdDui = sdDui;
   }

   public Long getSdDaiChan() {
      return sdDaiChan;
   }

   public void setSdDaiChan(Long sdDaiChan) {
      this.sdDaiChan = sdDaiChan;
   }

   public Double getSdChieuCao() {
      return sdChieuCao;
   }

   public void setSdChieuCao(Double sdChieuCao) {
      this.sdChieuCao = sdChieuCao;
   }

   public Double getSdCanNang() {
      return sdCanNang;
   }

   public void setSdCanNang(Double sdCanNang) {
      this.sdCanNang = sdCanNang;
   }

   public String getSdGioiTinhTuVan() {
      return sdGioiTinhTuVan;
   }

   public void setSdGioiTinhTuVan(String sdGioiTinhTuVan) {
      this.sdGioiTinhTuVan = sdGioiTinhTuVan;
   }

   public ThongTinThanhVien getThongTinThanhVien() {
      return thongTinThanhVien;
   }

   public void setThongTinThanhVien(ThongTinThanhVien thongTinThanhVien) {
      this.thongTinThanhVien = thongTinThanhVien;
   }
}
